The String Right node is used to include only a substring consisting of a given number of characters from a string column, moving from right to left. This is useful if the string contains a suffix that is private or not relevant for end-users for example.
Take the Right String
Start by connecting the String Right node to the Select node of the relevant table. Go to the Properties panel to define the substring:
Select Column: choose the relevant column from the drop down.
Characters to Take: enter the number of characters to be included in the substring, from right to left.
Column Output: decide whether or not to keep the original column.
New Column Name: name the new column.
Example. Take the Right Substring
In this example, the last 7 characters of the transactionID string column is included:
